![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
Results of TPC Benchmarks The current set of TPC results is available to the public from the TPC Web site: The Web site has information on the TPC benchmarks themselves as well as individual and complete results. Individual results are in the form of the Executive Summary. The Executive Summary is usually found in the front section of the Full Disclosure Report and contains the performance metrics, a listing of the hardware and software used in the benchmark, and a price breakdown. The Executive Summary also includes a diagram of the benchmarked configuration. The TPC results spreadsheet is available in SYLK, Adobe PDF, and Excel formats and contains a complete list of the current TPC benchmark results. As benchmarks become obsolete (as was the case for the TPC-A and TPC-B benchmarks), the results are removed from the official list. As new versions of benchmarks become available, there is usually a lag time during which the results from the old versions remain on the spreadsheet (eventually, the old results fall off the list). In some casessuch as for the change from TPC-C version 2.x to 3.0benchmark results can be upgraded for a limited time.
Although industry standard benchmarks cannot predict how your application will perform on a particular platform, the benchmarks are a good indicator of how competing platforms compare in these environments. Hopefully, TPC results can help you narrow down the choices to make your purchasing decision easier. Of course, the best indication of how well a particular application will run on a particular system is to benchmark it yourself. The process of developing a custom benchmark is briefly discussed later in this chapter. Publication BenchmarksSeveral publications have designed and built their own tests for benchmarking RDBMS products. Typically, the publication provides a good description of the test in the article that uses the results (Ziff-Davis labs and PC Week labs both do these types of tests). Many of these tests are very good and can provide you with insight about the performance of specific areas of RDBMS performance such as loading, backups, and so on. One thing to look for in these independent tests is the criteria that has been set up for the hardware and RDBMS products. Unlike the TPC benchmarks, these tests have a somewhat different goal in mind. Typically, publication benchmarks target a specific comparison (such as several different RDBMS products running on the same hardware or several hardware platforms running the same OS and database). These tests can be useful to compare systems but may not always show the most optimal configuration for that platform. Look at these tests carefully and decide whether they apply to you and give you useful information. Decide whether the tested configuration is realistic for you. If so, the results of these tests can be very useful.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |